Oracle Database Administrator DBA

Hello there,

Welcome to the Oracle Database Administrator DBA course.

This Oracle DBA course is one of the most awesome courses which teach step by step and follow methodology in introducing concepts and demos ( Learn by doing ) to the students so that they can learn with ease Oracle Database Administration.

In this course you will learn;

• Downloading Oracle Software,

• Database and RDBMS Concepts,

• DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ),

• Retrieving Data,

• Restricting And Sorting Data,

• Using Single-Row Functions and Customize Output,

• Using Conversion Functions and Conditional Expressions,

• Reporting Aggregated Data Using The Group Functions,

• Defining Table Joins and Displaying Data from multiple Tables,

• Using Subqueries,

• Using The Set Operators,

• Schema Objects And Managing Schema,

• Controlling User Access,

• Manipulating Large Data Sets and more!

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned developers expertise.

No Previous Knowledge is needed!

This course will take you from a beginner to a more experienced level.

If you are new to Oracle Database, or have no idea about what a DBA does no problem, you will learn anything you need to start Oracle Database.

If you are a DBA or familiar to the Oracle Database / Oracle SQL and you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples.

Fresh Content

You will find DBA's in almost every organization/business, to maintain the organization's database. Becoming a DBA is totaly depends on the knowledge you have in the overall architecture of Oracle Database. It’s no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it’s crucial to stay on top of the latest knowledge. With this course you will always have a chance to follow latest trends.

Video and Audio Production Quality

All our contents are created/produced as high quality video/audio to provide you the best learning experience.

You will be,

· Seeing clearly

· Hearing clearly

· Moving through the course without distractions

You'll also get:

Lifetime Access to The Course

Fast & Friendly Support in the Q&A section

Dive in now!

We offer full support, answering any questions.

See you in the course!

• Course Intro 01:19

  • 1: Oracle Database Administrator DBA Preview 01:19

• Getting Started to Oracle DBA 04:33

  • 2: What We Will Learn 03:33
  • 3: Project Files and Course Documents 01:00

• Setting Up 21:15

  • 4: Downloading Oracle Software 03:53
  • 5: Extracting Files 00:29
  • 6: Installing Oracle 12c Database 03:59
  • 7: Startup Instance on Windows 03:23
  • 8: Shutdown Instance 03:00
  • 9: Make SQL Developer Run Faster 01:48
  • 10: Oracle Live SQL 03:43
  • 11: quiz 01:00

• Installation of Oracle Database on Linux 38:25

  • 12: Download Virtualbox 00:55
  • 13: Download Linux 03:39
  • 14: Download Oracle Software 01:21
  • 15: Install Virtualbox 01:36
  • 16: Create Virtual Machine 01:09
  • 17: Install Linux 08:11
  • 18: Prerequests 11:02
  • 19: Oracle Software Installation 06:32
  • 20: Create Database 03:00
  • 21: quiz 01:00

• After Installations 07:54

  • 22: Startup & Shutdown Instance From Client 05:34
  • 23: Connect Database From Client 01:20
  • 24: quiz 01:00

• Database and RDBMS Concepts 17:08

  • 25: Learn Data, Database and RDBMS Concepts 16:08
  • 26: Quiz 01:00

• DDL ( Data Definition Language ) 25:16

  • 27: What is DDL 00:58
  • 28: Connect and Start to Create Objects 03:34
  • 29: Create Tablespace 01:37
  • 30: Create User 01:40
  • 31: Create Table 03:31
  • 32: Create Synonym 02:22
  • 33: Alter Objects 03:30
  • 34: Drop Objects 03:13
  • 35: Section Practice 03:51
  • 36: quiz 01:00

• DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ) 17:56

  • 37: DML and TCL 01:02
  • 38: Insert Data to Table 04:55
  • 39: Update Table Data 04:27
  • 40: Delete from Table 05:32
  • 41: quiz 02:00

• Retrieving, Restricting and Reporting Data 2:38:38

  • 42: Basic Select Statement 17:23
  • 43: Like Operator 04:32
  • 44: Sorting Data 05:11
  • 45: Limiting The Resultset 06:15
  • 46: Using Ampersand (&) Subtition 04:22
  • 47: Single Row Operators 03:50
  • 48: Single Row Functions 17:31
  • 49: Conversion Functions 13:48
  • 50: Using Group Functions 10:41
  • 51: Restricting Reported Data 02:16
  • 52: Joining Tables 30:10
  • 53: Using Subqueries 21:55
  • 54: Exists And Not Exists 03:41
  • 55: With Clause 03:51
  • 56: Using The Set Operators 07:32
  • 57: What We Have Learned 04:40
  • 58: quiz 01:00

• Schema Objects And Managing Schema 1:00:59

  • 59: Schema Objects With SQL Developer 53:02
  • 60: Using Dictionary Views To Manage Schema 05:43
  • 61: What We Have Learned In This Section 01:14
  • 62: quiz 01:00

• Controlling User Access 15:34

  • 63: Controlling User Access 13:49
  • 64: Section Summary 00:45
  • 65: quiz 01:00

• Manipulating Large Data Sets 18:02

  • 66: Manipulating Large Data Sets 15:42
  • 67: Section Summary 01:20
  • 68: quiz 01:00

• Tips & Tricks 31:22

  • 69: First Controls of Day 06:35
  • 70: Monthly Controls 07:54
  • 71: Useful Scripts Usage 04:16
  • 72: Opatch-AWR-ASH 05:30
  • 73: ORA Errors Solutions 07:07

• Homework 04:06

  • 74: Be Ready For The Homework 04:06

• What is Next? 01:56

  • 75: What should be the next step to become DBA 01:56

Hello there,

Welcome to the Oracle Database Administrator DBA course.

This Oracle DBA course is one of the most awesome courses which teach step by step and follow methodology in introducing concepts and demos ( Learn by doing ) to the students so that they can learn with ease Oracle Database Administration.

In this course you will learn;

• Downloading Oracle Software,

• Database and RDBMS Concepts,

• DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ),

• Retrieving Data,

• Restricting And Sorting Data,

• Using Single-Row Functions and Customize Output,

• Using Conversion Functions and Conditional Expressions,

• Reporting Aggregated Data Using The Group Functions,

• Defining Table Joins and Displaying Data from multiple Tables,

• Using Subqueries,

• Using The Set Operators,

• Schema Objects And Managing Schema,

• Controlling User Access,

• Manipulating Large Data Sets and more!

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned developers expertise.

No Previous Knowledge is needed!

This course will take you from a beginner to a more experienced level.

If you are new to Oracle Database, or have no idea about what a DBA does no problem, you will learn anything you need to start Oracle Database.

If you are a DBA or familiar to the Oracle Database / Oracle SQL and you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples.

Fresh Content

You will find DBA's in almost every organization/business, to maintain the organization's database. Becoming a DBA is totaly depends on the knowledge you have in the overall architecture of Oracle Database. It’s no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it’s crucial to stay on top of the latest knowledge. With this course you will always have a chance to follow latest trends.

Video and Audio Production Quality

All our contents are created/produced as high quality video/audio to provide you the best learning experience.

You will be,

· Seeing clearly

· Hearing clearly

· Moving through the course without distractions

You'll also get:

Lifetime Access to The Course

Fast & Friendly Support in the Q&A section

Dive in now!

We offer full support, answering any questions.

See you in the course!

• Anyone who wants to become an Oracle DBA
• Anyone who plans a career in Oracle Data Administration
• Software developers whom want to increase SQL knwoledge
• Anyone who are studying Oracle 1Z0-071 Exams
• Anyone who are junior Oracle DBA's
• Anyone who are manage RDBMS and want to immigrate Oracle

• No prior knowledge is required!
• Basic Computer Knowledge
• Desire to learn Oracle Database Administration
• We prefered Windows OS , but this is not mandatory. You can prefer to use other Operating Systems
• Nothing else! It’s just you, your computer and your ambition to get started today
• LIFETIME ACCESS, course updates, new content, anytime, anywhere, on any device
• This is one of the most amazing Udemy courses in Oracle SQL

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included